package com.xpgk.mvc.ddc.ddc_penalties;

import java.util.List;
import com.jfinal.log.Log;
import com.xpgk.annotation.Service;
import com.xpgk.mvc.base.BaseService;

@Service(name = DDC_PenaltiesService.serviceName)
public class DDC_PenaltiesService  extends  BaseService{
	
	@SuppressWarnings("unused")
	private static final Log log = Log.getLog(DDC_PenaltiesService.class);
	public static final String serviceName = "penaltiesService";	
	
	/**
	 * 查询违法类型
	 */
	public List<Penalties> getPenalties() {

//		String sql1 = "SELECT code,concat(code,':',content) as codecontent from ddc_penalties order by id";
		String sql1 = "SELECT CODE,CODE||'_'||CODECONTENT AS CODECONTENT FROM DDC_PENALTIES ORDER BY ID";
		List<Penalties> list_penalties = Penalties.dao.find(sql1);
		return list_penalties;
	}
	
}
	


